﻿CREATE TABLE [dbo].[DefinedSecurityAttributeAccess] (
    [AttributeAccessID]     INT            IDENTITY (1, 1) NOT NULL,
    [ShortRelationshipName] NVARCHAR (50)  NOT NULL,
    [EntityType]            NVARCHAR (100) NOT NULL,
    [EntitySubtype]         NVARCHAR (100) NULL,
    [AttributeName]         NVARCHAR (255) NOT NULL,
    [AccessLevel]           INT            NOT NULL,
    CONSTRAINT [PK_DefinedSecurityAttributeAccess] PRIMARY KEY CLUSTERED ([AttributeAccessID] ASC),
    CONSTRAINT [FK_DefinedSecurityAttributeAccess_DefinedSecurityLevels] FOREIGN KEY ([AccessLevel]) REFERENCES [dbo].[DefinedSecurityLevels] ([SecurityLevel]) ON UPDATE CASCADE
);







